MySQL Server Syntax to create the table for Host Header Logging

To create the table for Packet Logging with a minimal set of fields:

create table hosts (
   ts timestamp,
   rtime datetime,
   filterid smallint  NOT NULL,
   rtype smallint,
   method smallint,
   reason smallint,
   clt_ip char(16),
   clt_port smallint unsigned,
   srv_ip char(16),
   srv_port smallint unsigned,
   clt_bytes int unsigned, 
   srv_bytes int unsigned,
   host char(250)); 

 Note

• Field "ts" points to a time when the record was created. Microsoft SQL Server must automatically insert the current date and time in the table with new record. Therefore, you should use the field with "timestamp" type.